# Configuration directives required by the setuphandlers.py
# script files	
# Change these to suit your enviornemt
# TODO Delete this file after install

#############################################
# Database Connection Object Settings		#
# Z Psycopg 2 Database Connection 			#
#############################################
NEW_LINE = "\r\n"

DB_ID = "PsycoPgConnection"
DB_TITLE = " Postgres Authentication Database Connection"
DB_NAME = "databasename"
DB_USERNAME = "username"
DB_PASSWORD = "password"
DB_CONNECTION_STRING = "dbname=%s user=%s password=%s" %(DB_NAME, DB_USERNAME, DB_PASSWORD)
DB_USE_ZOPE_INTERNAL_DATETIME = True

#use 2 for Serializable, 1 for Read commited
DB_TRANSACTION_ISOLATION_LEVEL = 2
DB_ENCODING = "UTF-8"


#############################################
# Database specific parameters requred to	#
# to set up table mapping to SQLAuth Plugin	#
# properties. Should match the schemas and	#
# and relations in your database			#
#############################################

SG_GROUPS_TABLE = "groups"
SG_GROUPNAME_COLUMN = "groupname"
SG_USERNAME_COLUMN = "username"

SP_USERS_TABLE = "users"
SP_USERS_COLUMN_USERNAME = "username"
SP_USERS_COLUMN_PASSWORD = "password"

# column mappings for user properties
# format <plone property>/<db column>
SP_COLUMN_MAPPING = "email/email" + NEW_LINE + "full_name/fullname"

SR_ROLES_TABLE = "roles"
SR_ROLES_COLUMN_USERNAME = "username"
SR_ROLES_COLUMN_ROLENAME = "rolename"

# not using this setting in this setup
#SP_ROLES_MAPPING = []

SU_USERS_TABLE = "users"
SU_USERS_COLUMN_USERNAME = "username"
SU_USERS_COLUMN_PASSWORD = "password"
SU_USERS_DEFAULT_ENCRYPTION = "md5"
